CONNECT BY PUMP
Short Description
CONNECT BY describes how LEVELs are created within hierarchical queries. The PUMP node feeds data up the tree.
Detailed Description
CONNECT BY describes how LEVELs are created within hierarchical queries. The PUMP node feeds data for child records up the tree to their parents.
Additional Links
- Tim Hall’s Oracle Base viedo clip - Hierarchical Queries in Oracle
- Oracle SQL Ref - Hierarchical Queries
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.